package com.empire.module.spider.dal.mysql.lotteryfootballmatch500wan;

import java.util.*;

import com.empire.framework.common.pojo.PageResult;
import com.empire.framework.mybatis.core.query.LambdaQueryWrapperX;
import com.empire.framework.mybatis.core.mapper.BaseMapperX;
import com.empire.module.spider.dal.dataobject.lotteryfootballmatch500wan.LotteryFootballMatch500wanDO;
import org.apache.ibatis.annotations.Mapper;
import com.empire.module.spider.controller.app.lotteryfootballmatch500wan.vo.*;

/**
 * 足彩比赛 Mapper
 *
 * @author 无敌
 */
@Mapper
public interface LotteryFootballMatch500wanMapper extends BaseMapperX<LotteryFootballMatch500wanDO> {

    default PageResult<LotteryFootballMatch500wanDO> selectPage(AppLotteryFootballMatch500wanPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<LotteryFootballMatch500wanDO>()
                .eqIfPresent(LotteryFootballMatch500wanDO::getMatchStatus, reqVO.getMatchStatus())
                .eqIfPresent(LotteryFootballMatch500wanDO::getContest, reqVO.getContest())
                .eqIfPresent(LotteryFootballMatch500wanDO::getMatchRound, reqVO.getMatchRound())
                .betweenIfPresent(LotteryFootballMatch500wanDO::getMatchTime, reqVO.getMatchTime())
                .eqIfPresent(LotteryFootballMatch500wanDO::getHomeTeam, reqVO.getHomeTeam())
                .eqIfPresent(LotteryFootballMatch500wanDO::getAwayTeam, reqVO.getAwayTeam())
                .eqIfPresent(LotteryFootballMatch500wanDO::getHomeTeamRanking, reqVO.getHomeTeamRanking())
                .eqIfPresent(LotteryFootballMatch500wanDO::getAwayTeamRanking, reqVO.getAwayTeamRanking())
                .eqIfPresent(LotteryFootballMatch500wanDO::getHomeTeamUrl, reqVO.getHomeTeamUrl())
                .eqIfPresent(LotteryFootballMatch500wanDO::getAwayTeamUrl, reqVO.getAwayTeamUrl())
                .eqIfPresent(LotteryFootballMatch500wanDO::getOdds, reqVO.getOdds())
                .eqIfPresent(LotteryFootballMatch500wanDO::getMatchLine, reqVO.getMatchLine())
                .eqIfPresent(LotteryFootballMatch500wanDO::getHomeTeamHalfScore, reqVO.getHomeTeamHalfScore())
                .eqIfPresent(LotteryFootballMatch500wanDO::getAwayTeamHalfScore, reqVO.getAwayTeamHalfScore())
                .eqIfPresent(LotteryFootballMatch500wanDO::getHomeTeamScore, reqVO.getHomeTeamScore())
                .eqIfPresent(LotteryFootballMatch500wanDO::getAwayTeamScore, reqVO.getAwayTeamScore())
                .betweenIfPresent(LotteryFootballMatch500wanDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(LotteryFootballMatch500wanDO::getFid));
    }

}
